﻿-- =============================================
-- Author:		<Author,XFL>
-- Create date: <Create Date,20111226>
-- Description:	<Description,工资列表 获取 已审核的全部数据 在职、离职 都计算在内>
-- =============================================
CREATE PROCEDURE [dbo].[proc_Wage_Getlist_HRFlag2] 

(		
		@CompanyId int,
		@Month nvarchar(7)
)
AS
BEGIN

	SET NOCOUNT ON;


;WITH list As(	SELECT 
		UserName 
		,Id
		,GId
		,Guid_str
	From Employee_Wage Where CompanyId=@CompanyId  and Convert(nchar(7),FaFangMonth,120)=@Month and HRFlag=2
)
	Select * From list
END

RETURN
